SUPPORT / SAMPLES & SAS NOTES
Problem Note 37374: Poor performance when exporting unformatted numeric data from SAS® Web Report Studio to Microsoft Excel
 |  |  |  |
In SAS Web Report Studio, when exporting from the View Detail window, performance might be very slow. In addition, the log might contain the following warning message:
WARN [] com.sas.storage.jdbc.export - BESTFIT is an invalid SAS format name because does not contain the dot . character
This problem is most likely to occur if the numeric columns have no format or if they are using the standard numeric format (w.d) on the physical table. To circumvent the problem, do one of the following:
- Change the column format to something other than the standard w.d format. For example, change the format to F6. or F12.
- For com.sas.storage.jdbc, change the logging level to ERROR instead of WARN.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | z/OS | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| HP-UX IPF | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Linux for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Solaris for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||